IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tsAutoStatus]') AND type in (N'U'))
DROP TABLE [dbo].[tsAutoStatus]

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tsAddTimesheet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tsAddTimesheet]

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tsGetUnprocessedTimesheets]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tsGetUnprocessedTimesheets]

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tsSetTimesheetProcessed]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tsSetTimesheetProcessed]

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tsSetTimesheetFailed') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tsSetTimesheetFailed]
